package server.db.primary.mapper.map;

import org.apache.ibatis.annotations.Param;
import server.db.primary.model.map.Affiche;
import server.db.primary.model.map.Seal;

import java.util.List;

public interface AfficheMapper {
    int deleteByPrimaryKey(Long id);

    int insert(Affiche record);

    int insertSelective(Affiche record);

    Affiche selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Affiche record);

    int updateByPrimaryKey(Affiche record);

    List<Affiche> selectBynumberId ();

    List<Affiche> selectByAll();

    List<Affiche> selectBymark (@Param("mark")Integer mark, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectBymark (@Param("timeStart") String timeStart, @Param("timeEnd") String timeEnd);

    List<Affiche> selectstationUserId(@Param("stationUserId") Integer stationUserId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectwellUserId(@Param("wellUserId") Integer wellUserId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectdone(@Param("userId") Integer userId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectUserId(@Param("userId") Integer userId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectguidang(@Param("userId") Integer userId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd, @Param("timeStart1") String timeStart1, @Param("timeEnd1")String timeEnd1);

    List<Affiche> selectByuserId (@Param("afficheId") Integer afficheId,@Param("mark1") Integer mark1, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectnotBywelluserId (@Param("userId") Integer userId, @Param("wellUserId") Integer wellUserId, @Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd, @Param("timeStart1") String timeStart1, @Param("timeEnd1")String timeEnd1);

    List<Affiche> selectBywelluserId (@Param("userId") Integer userId,@Param("wellUserId") Integer wellUserId,@Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd,@Param("timeStart1") String timeStart1, @Param("timeEnd1")String timeEnd1);

    List<Affiche> selectBywelluserIdmark (@Param("userId") Integer userId,@Param("wellUserId") Integer wellUserId,@Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd,@Param("timeStart1") String timeStart1, @Param("timeEnd1")String timeEnd1);

    List<Affiche> selectnotBystationuserId (@Param("stationUserId") Integer stationUserId,@Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectBystationuserId (@Param("stationUserId") Integer stationUserId,@Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectBystationuserIdmark (@Param("stationUserId") Integer stationUserId,@Param("timeStart") String timeStart, @Param("timeEnd")String timeEnd);

    List<Affiche> selectnotBymark (@Param("mark") Integer mark, @Param("timeStart") String timeStart, @Param("timeEnd") String timeEnd);
}